package com.deyuanyun.pic.ctrl.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EqptCurrentDrainageExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EqptCurrentDrainageExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNull() {
            addCriterion("CREATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNotNull() {
            addCriterion("CREATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkEqualTo(String value) {
            addCriterion("CREATE_REMARK =", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotEqualTo(String value) {
            addCriterion("CREATE_REMARK <>", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThan(String value) {
            addCriterion("CREATE_REMARK >", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK >=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThan(String value) {
            addCriterion("CREATE_REMARK <", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK <=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLike(String value) {
            addCriterion("CREATE_REMARK like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotLike(String value) {
            addCriterion("CREATE_REMARK not like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIn(List<String> values) {
            addCriterion("CREATE_REMARK in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotIn(List<String> values) {
            addCriterion("CREATE_REMARK not in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK not between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNull() {
            addCriterion("UPDATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNotNull() {
            addCriterion("UPDATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkEqualTo(String value) {
            addCriterion("UPDATE_REMARK =", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotEqualTo(String value) {
            addCriterion("UPDATE_REMARK <>", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThan(String value) {
            addCriterion("UPDATE_REMARK >", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK >=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThan(String value) {
            addCriterion("UPDATE_REMARK <", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK <=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLike(String value) {
            addCriterion("UPDATE_REMARK like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotLike(String value) {
            addCriterion("UPDATE_REMARK not like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIn(List<String> values) {
            addCriterion("UPDATE_REMARK in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotIn(List<String> values) {
            addCriterion("UPDATE_REMARK not in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK not between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("DELETED is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("DELETED =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("DELETED <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("DELETED >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETED >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("DELETED <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("DELETED <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("DELETED in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("DELETED not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("DELETED between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("DELETED not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("VERSION is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("VERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Short value) {
            addCriterion("VERSION =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Short value) {
            addCriterion("VERSION <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Short value) {
            addCriterion("VERSION >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Short value) {
            addCriterion("VERSION >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Short value) {
            addCriterion("VERSION <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Short value) {
            addCriterion("VERSION <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Short> values) {
            addCriterion("VERSION in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Short> values) {
            addCriterion("VERSION not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Short value1, Short value2) {
            addCriterion("VERSION between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Short value1, Short value2) {
            addCriterion("VERSION not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNull() {
            addCriterion("IS_NEWEST is null");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNotNull() {
            addCriterion("IS_NEWEST is not null");
            return (Criteria) this;
        }

        public Criteria andIsNewestEqualTo(Short value) {
            addCriterion("IS_NEWEST =", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotEqualTo(Short value) {
            addCriterion("IS_NEWEST <>", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThan(Short value) {
            addCriterion("IS_NEWEST >", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST >=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThan(Short value) {
            addCriterion("IS_NEWEST <", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST <=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestIn(List<Short> values) {
            addCriterion("IS_NEWEST in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotIn(List<Short> values) {
            addCriterion("IS_NEWEST not in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST not between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNull() {
            addCriterion("DATA_STATED is null");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNotNull() {
            addCriterion("DATA_STATED is not null");
            return (Criteria) this;
        }

        public Criteria andDataStatedEqualTo(String value) {
            addCriterion("DATA_STATED =", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotEqualTo(String value) {
            addCriterion("DATA_STATED <>", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThan(String value) {
            addCriterion("DATA_STATED >", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThanOrEqualTo(String value) {
            addCriterion("DATA_STATED >=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThan(String value) {
            addCriterion("DATA_STATED <", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThanOrEqualTo(String value) {
            addCriterion("DATA_STATED <=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLike(String value) {
            addCriterion("DATA_STATED like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotLike(String value) {
            addCriterion("DATA_STATED not like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedIn(List<String> values) {
            addCriterion("DATA_STATED in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotIn(List<String> values) {
            addCriterion("DATA_STATED not in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedBetween(String value1, String value2) {
            addCriterion("DATA_STATED between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotBetween(String value1, String value2) {
            addCriterion("DATA_STATED not between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIsNull() {
            addCriterion("CUSTOM_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIsNotNull() {
            addCriterion("CUSTOM_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andCustomNumberEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER =", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER <>", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberGreaterThan(String value) {
            addCriterion("CUSTOM_NUMBER >", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER >=", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLessThan(String value) {
            addCriterion("CUSTOM_NUMBER <", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLessThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER <=", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLike(String value) {
            addCriterion("CUSTOM_NUMBER like", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotLike(String value) {
            addCriterion("CUSTOM_NUMBER not like", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIn(List<String> values) {
            addCriterion("CUSTOM_NUMBER in", values, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotIn(List<String> values) {
            addCriterion("CUSTOM_NUMBER not in", values, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberBetween(String value1, String value2) {
            addCriterion("CUSTOM_NUMBER between", value1, value2, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotBetween(String value1, String value2) {
            addCriterion("CUSTOM_NUMBER not between", value1, value2, "customNumber");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNull() {
            addCriterion("PIPE_LINE_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNotNull() {
            addCriterion("PIPE_LINE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdEqualTo(String value) {
            addCriterion("PIPE_LINE_ID =", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <>", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThan(String value) {
            addCriterion("PIPE_LINE_ID >", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID >=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThan(String value) {
            addCriterion("PIPE_LINE_ID <", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLike(String value) {
            addCriterion("PIPE_LINE_ID like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotLike(String value) {
            addCriterion("PIPE_LINE_ID not like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIn(List<String> values) {
            addCriterion("PIPE_LINE_ID in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotIn(List<String> values) {
            addCriterion("PIPE_LINE_ID not in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID not between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdIsNull() {
            addCriterion("PIPE_VALVEROOM_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdIsNotNull() {
            addCriterion("PIPE_VALVEROOM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID =", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID <>", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdGreaterThan(String value) {
            addCriterion("PIPE_VALVEROOM_ID >", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID >=", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdLessThan(String value) {
            addCriterion("PIPE_VALVEROOM_ID <", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID <=", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdLike(String value) {
            addCriterion("PIPE_VALVEROOM_ID like", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotLike(String value) {
            addCriterion("PIPE_VALVEROOM_ID not like", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdIn(List<String> values) {
            addCriterion("PIPE_VALVEROOM_ID in", values, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotIn(List<String> values) {
            addCriterion("PIPE_VALVEROOM_ID not in", values, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdBetween(String value1, String value2) {
            addCriterion("PIPE_VALVEROOM_ID between", value1, value2, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_VALVEROOM_ID not between", value1, value2, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdIsNull() {
            addCriterion("TEST_STATION_ID is null");
            return (Criteria) this;
        }

        public Criteria andTestStationIdIsNotNull() {
            addCriterion("TEST_STATION_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTestStationIdEqualTo(String value) {
            addCriterion("TEST_STATION_ID =", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdNotEqualTo(String value) {
            addCriterion("TEST_STATION_ID <>", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdGreaterThan(String value) {
            addCriterion("TEST_STATION_ID >", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdGreaterThanOrEqualTo(String value) {
            addCriterion("TEST_STATION_ID >=", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdLessThan(String value) {
            addCriterion("TEST_STATION_ID <", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdLessThanOrEqualTo(String value) {
            addCriterion("TEST_STATION_ID <=", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdLike(String value) {
            addCriterion("TEST_STATION_ID like", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdNotLike(String value) {
            addCriterion("TEST_STATION_ID not like", value, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdIn(List<String> values) {
            addCriterion("TEST_STATION_ID in", values, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdNotIn(List<String> values) {
            addCriterion("TEST_STATION_ID not in", values, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdBetween(String value1, String value2) {
            addCriterion("TEST_STATION_ID between", value1, value2, "testStationId");
            return (Criteria) this;
        }

        public Criteria andTestStationIdNotBetween(String value1, String value2) {
            addCriterion("TEST_STATION_ID not between", value1, value2, "testStationId");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageIsNull() {
            addCriterion("CURRENTDRAINAGE is null");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageIsNotNull() {
            addCriterion("CURRENTDRAINAGE is not null");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageEqualTo(String value) {
            addCriterion("CURRENTDRAINAGE =", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageNotEqualTo(String value) {
            addCriterion("CURRENTDRAINAGE <>", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageGreaterThan(String value) {
            addCriterion("CURRENTDRAINAGE >", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageGreaterThanOrEqualTo(String value) {
            addCriterion("CURRENTDRAINAGE >=", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageLessThan(String value) {
            addCriterion("CURRENTDRAINAGE <", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageLessThanOrEqualTo(String value) {
            addCriterion("CURRENTDRAINAGE <=", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageLike(String value) {
            addCriterion("CURRENTDRAINAGE like", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageNotLike(String value) {
            addCriterion("CURRENTDRAINAGE not like", value, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageIn(List<String> values) {
            addCriterion("CURRENTDRAINAGE in", values, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageNotIn(List<String> values) {
            addCriterion("CURRENTDRAINAGE not in", values, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageBetween(String value1, String value2) {
            addCriterion("CURRENTDRAINAGE between", value1, value2, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andCurrentdrainageNotBetween(String value1, String value2) {
            addCriterion("CURRENTDRAINAGE not between", value1, value2, "currentdrainage");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeIsNull() {
            addCriterion("GROUNDING_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeIsNotNull() {
            addCriterion("GROUNDING_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeEqualTo(String value) {
            addCriterion("GROUNDING_TYPE =", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeNotEqualTo(String value) {
            addCriterion("GROUNDING_TYPE <>", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeGreaterThan(String value) {
            addCriterion("GROUNDING_TYPE >", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeGreaterThanOrEqualTo(String value) {
            addCriterion("GROUNDING_TYPE >=", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeLessThan(String value) {
            addCriterion("GROUNDING_TYPE <", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeLessThanOrEqualTo(String value) {
            addCriterion("GROUNDING_TYPE <=", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeLike(String value) {
            addCriterion("GROUNDING_TYPE like", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeNotLike(String value) {
            addCriterion("GROUNDING_TYPE not like", value, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeIn(List<String> values) {
            addCriterion("GROUNDING_TYPE in", values, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeNotIn(List<String> values) {
            addCriterion("GROUNDING_TYPE not in", values, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeBetween(String value1, String value2) {
            addCriterion("GROUNDING_TYPE between", value1, value2, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGroundingTypeNotBetween(String value1, String value2) {
            addCriterion("GROUNDING_TYPE not between", value1, value2, "groundingType");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureIsNull() {
            addCriterion("GROUN_DBE_DSTRUCTURE is null");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureIsNotNull() {
            addCriterion("GROUN_DBE_DSTRUCTURE is not null");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureEqualTo(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE =", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureNotEqualTo(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE <>", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureGreaterThan(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE >", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureGreaterThanOrEqualTo(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE >=", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureLessThan(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE <", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureLessThanOrEqualTo(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE <=", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureLike(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE like", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureNotLike(String value) {
            addCriterion("GROUN_DBE_DSTRUCTURE not like", value, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureIn(List<String> values) {
            addCriterion("GROUN_DBE_DSTRUCTURE in", values, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureNotIn(List<String> values) {
            addCriterion("GROUN_DBE_DSTRUCTURE not in", values, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureBetween(String value1, String value2) {
            addCriterion("GROUN_DBE_DSTRUCTURE between", value1, value2, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andGrounDbeDstructureNotBetween(String value1, String value2) {
            addCriterion("GROUN_DBE_DSTRUCTURE not between", value1, value2, "grounDbeDstructure");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeIsNull() {
            addCriterion("INTERFERENCE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeIsNotNull() {
            addCriterion("INTERFERENCE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeEqualTo(String value) {
            addCriterion("INTERFERENCE_TYPE =", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeNotEqualTo(String value) {
            addCriterion("INTERFERENCE_TYPE <>", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeGreaterThan(String value) {
            addCriterion("INTERFERENCE_TYPE >", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("INTERFERENCE_TYPE >=", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeLessThan(String value) {
            addCriterion("INTERFERENCE_TYPE <", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeLessThanOrEqualTo(String value) {
            addCriterion("INTERFERENCE_TYPE <=", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeLike(String value) {
            addCriterion("INTERFERENCE_TYPE like", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeNotLike(String value) {
            addCriterion("INTERFERENCE_TYPE not like", value, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeIn(List<String> values) {
            addCriterion("INTERFERENCE_TYPE in", values, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeNotIn(List<String> values) {
            addCriterion("INTERFERENCE_TYPE not in", values, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeBetween(String value1, String value2) {
            addCriterion("INTERFERENCE_TYPE between", value1, value2, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andInterferenceTypeNotBetween(String value1, String value2) {
            addCriterion("INTERFERENCE_TYPE not between", value1, value2, "interferenceType");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodIsNull() {
            addCriterion("DRAINAGE_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodIsNotNull() {
            addCriterion("DRAINAGE_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodEqualTo(String value) {
            addCriterion("DRAINAGE_METHOD =", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodNotEqualTo(String value) {
            addCriterion("DRAINAGE_METHOD <>", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodGreaterThan(String value) {
            addCriterion("DRAINAGE_METHOD >", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodGreaterThanOrEqualTo(String value) {
            addCriterion("DRAINAGE_METHOD >=", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodLessThan(String value) {
            addCriterion("DRAINAGE_METHOD <", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodLessThanOrEqualTo(String value) {
            addCriterion("DRAINAGE_METHOD <=", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodLike(String value) {
            addCriterion("DRAINAGE_METHOD like", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodNotLike(String value) {
            addCriterion("DRAINAGE_METHOD not like", value, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodIn(List<String> values) {
            addCriterion("DRAINAGE_METHOD in", values, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodNotIn(List<String> values) {
            addCriterion("DRAINAGE_METHOD not in", values, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodBetween(String value1, String value2) {
            addCriterion("DRAINAGE_METHOD between", value1, value2, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andDrainageMethodNotBetween(String value1, String value2) {
            addCriterion("DRAINAGE_METHOD not between", value1, value2, "drainageMethod");
            return (Criteria) this;
        }

        public Criteria andSolderGisidIsNull() {
            addCriterion("SOLDER_GISID is null");
            return (Criteria) this;
        }

        public Criteria andSolderGisidIsNotNull() {
            addCriterion("SOLDER_GISID is not null");
            return (Criteria) this;
        }

        public Criteria andSolderGisidEqualTo(String value) {
            addCriterion("SOLDER_GISID =", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidNotEqualTo(String value) {
            addCriterion("SOLDER_GISID <>", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidGreaterThan(String value) {
            addCriterion("SOLDER_GISID >", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidGreaterThanOrEqualTo(String value) {
            addCriterion("SOLDER_GISID >=", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidLessThan(String value) {
            addCriterion("SOLDER_GISID <", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidLessThanOrEqualTo(String value) {
            addCriterion("SOLDER_GISID <=", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidLike(String value) {
            addCriterion("SOLDER_GISID like", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidNotLike(String value) {
            addCriterion("SOLDER_GISID not like", value, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidIn(List<String> values) {
            addCriterion("SOLDER_GISID in", values, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidNotIn(List<String> values) {
            addCriterion("SOLDER_GISID not in", values, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidBetween(String value1, String value2) {
            addCriterion("SOLDER_GISID between", value1, value2, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderGisidNotBetween(String value1, String value2) {
            addCriterion("SOLDER_GISID not between", value1, value2, "solderGisid");
            return (Criteria) this;
        }

        public Criteria andSolderMileageIsNull() {
            addCriterion("SOLDER_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andSolderMileageIsNotNull() {
            addCriterion("SOLDER_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andSolderMileageEqualTo(Long value) {
            addCriterion("SOLDER_MILEAGE =", value, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageNotEqualTo(Long value) {
            addCriterion("SOLDER_MILEAGE <>", value, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageGreaterThan(Long value) {
            addCriterion("SOLDER_MILEAGE >", value, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageGreaterThanOrEqualTo(Long value) {
            addCriterion("SOLDER_MILEAGE >=", value, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageLessThan(Long value) {
            addCriterion("SOLDER_MILEAGE <", value, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageLessThanOrEqualTo(Long value) {
            addCriterion("SOLDER_MILEAGE <=", value, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageIn(List<Integer> values) {
            addCriterion("SOLDER_MILEAGE in", values, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageNotIn(List<Integer> values) {
            addCriterion("SOLDER_MILEAGE not in", values, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageBetween(Long value1, Long value2) {
            addCriterion("SOLDER_MILEAGE between", value1, value2, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderMileageNotBetween(Long value1, Long value2) {
            addCriterion("SOLDER_MILEAGE not between", value1, value2, "solderMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmIsNull() {
            addCriterion("SOLDER_NAGM is null");
            return (Criteria) this;
        }

        public Criteria andSolderNagmIsNotNull() {
            addCriterion("SOLDER_NAGM is not null");
            return (Criteria) this;
        }

        public Criteria andSolderNagmEqualTo(String value) {
            addCriterion("SOLDER_NAGM =", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmNotEqualTo(String value) {
            addCriterion("SOLDER_NAGM <>", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmGreaterThan(String value) {
            addCriterion("SOLDER_NAGM >", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmGreaterThanOrEqualTo(String value) {
            addCriterion("SOLDER_NAGM >=", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmLessThan(String value) {
            addCriterion("SOLDER_NAGM <", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmLessThanOrEqualTo(String value) {
            addCriterion("SOLDER_NAGM <=", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmLike(String value) {
            addCriterion("SOLDER_NAGM like", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmNotLike(String value) {
            addCriterion("SOLDER_NAGM not like", value, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmIn(List<String> values) {
            addCriterion("SOLDER_NAGM in", values, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmNotIn(List<String> values) {
            addCriterion("SOLDER_NAGM not in", values, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmBetween(String value1, String value2) {
            addCriterion("SOLDER_NAGM between", value1, value2, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmNotBetween(String value1, String value2) {
            addCriterion("SOLDER_NAGM not between", value1, value2, "solderNagm");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageIsNull() {
            addCriterion("SOLDER_NAGM_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageIsNotNull() {
            addCriterion("SOLDER_NAGM_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageEqualTo(Long value) {
            addCriterion("SOLDER_NAGM_MILEAGE =", value, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageNotEqualTo(Long value) {
            addCriterion("SOLDER_NAGM_MILEAGE <>", value, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageGreaterThan(Long value) {
            addCriterion("SOLDER_NAGM_MILEAGE >", value, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageGreaterThanOrEqualTo(Long value) {
            addCriterion("SOLDER_NAGM_MILEAGE >=", value, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageLessThan(Long value) {
            addCriterion("SOLDER_NAGM_MILEAGE <", value, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageLessThanOrEqualTo(Long value) {
            addCriterion("SOLDER_NAGM_MILEAGE <=", value, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageIn(List<Integer> values) {
            addCriterion("SOLDER_NAGM_MILEAGE in", values, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageNotIn(List<Integer> values) {
            addCriterion("SOLDER_NAGM_MILEAGE not in", values, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageBetween(Long value1, Long value2) {
            addCriterion("SOLDER_NAGM_MILEAGE between", value1, value2, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andSolderNagmMileageNotBetween(Long value1, Long value2) {
            addCriterion("SOLDER_NAGM_MILEAGE not between", value1, value2, "solderNagmMileage");
            return (Criteria) this;
        }

        public Criteria andGisidIsNull() {
            addCriterion("GISID is null");
            return (Criteria) this;
        }

        public Criteria andGisidIsNotNull() {
            addCriterion("GISID is not null");
            return (Criteria) this;
        }

        public Criteria andGisidEqualTo(String value) {
            addCriterion("GISID =", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidNotEqualTo(String value) {
            addCriterion("GISID <>", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidGreaterThan(String value) {
            addCriterion("GISID >", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidGreaterThanOrEqualTo(String value) {
            addCriterion("GISID >=", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidLessThan(String value) {
            addCriterion("GISID <", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidLessThanOrEqualTo(String value) {
            addCriterion("GISID <=", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidLike(String value) {
            addCriterion("GISID like", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidNotLike(String value) {
            addCriterion("GISID not like", value, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidIn(List<String> values) {
            addCriterion("GISID in", values, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidNotIn(List<String> values) {
            addCriterion("GISID not in", values, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidBetween(String value1, String value2) {
            addCriterion("GISID between", value1, value2, "gisid");
            return (Criteria) this;
        }

        public Criteria andGisidNotBetween(String value1, String value2) {
            addCriterion("GISID not between", value1, value2, "gisid");
            return (Criteria) this;
        }

        public Criteria andBeginNagmIsNull() {
            addCriterion("BEGIN_NAGM is null");
            return (Criteria) this;
        }

        public Criteria andBeginNagmIsNotNull() {
            addCriterion("BEGIN_NAGM is not null");
            return (Criteria) this;
        }

        public Criteria andBeginNagmEqualTo(String value) {
            addCriterion("BEGIN_NAGM =", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmNotEqualTo(String value) {
            addCriterion("BEGIN_NAGM <>", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmGreaterThan(String value) {
            addCriterion("BEGIN_NAGM >", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmGreaterThanOrEqualTo(String value) {
            addCriterion("BEGIN_NAGM >=", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmLessThan(String value) {
            addCriterion("BEGIN_NAGM <", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmLessThanOrEqualTo(String value) {
            addCriterion("BEGIN_NAGM <=", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmLike(String value) {
            addCriterion("BEGIN_NAGM like", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmNotLike(String value) {
            addCriterion("BEGIN_NAGM not like", value, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmIn(List<String> values) {
            addCriterion("BEGIN_NAGM in", values, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmNotIn(List<String> values) {
            addCriterion("BEGIN_NAGM not in", values, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmBetween(String value1, String value2) {
            addCriterion("BEGIN_NAGM between", value1, value2, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmNotBetween(String value1, String value2) {
            addCriterion("BEGIN_NAGM not between", value1, value2, "beginNagm");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageIsNull() {
            addCriterion("BEGIN_NAGM_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageIsNotNull() {
            addCriterion("BEGIN_NAGM_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageEqualTo(Long value) {
            addCriterion("BEGIN_NAGM_MILEAGE =", value, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageNotEqualTo(Long value) {
            addCriterion("BEGIN_NAGM_MILEAGE <>", value, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageGreaterThan(Long value) {
            addCriterion("BEGIN_NAGM_MILEAGE >", value, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageGreaterThanOrEqualTo(Long value) {
            addCriterion("BEGIN_NAGM_MILEAGE >=", value, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageLessThan(Long value) {
            addCriterion("BEGIN_NAGM_MILEAGE <", value, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageLessThanOrEqualTo(Long value) {
            addCriterion("BEGIN_NAGM_MILEAGE <=", value, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageIn(List<Integer> values) {
            addCriterion("BEGIN_NAGM_MILEAGE in", values, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageNotIn(List<Integer> values) {
            addCriterion("BEGIN_NAGM_MILEAGE not in", values, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageBetween(Long value1, Long value2) {
            addCriterion("BEGIN_NAGM_MILEAGE between", value1, value2, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginNagmMileageNotBetween(Long value1, Long value2) {
            addCriterion("BEGIN_NAGM_MILEAGE not between", value1, value2, "beginNagmMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageIsNull() {
            addCriterion("BEGIN_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andBeginMileageIsNotNull() {
            addCriterion("BEGIN_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andBeginMileageEqualTo(Long value) {
            addCriterion("BEGIN_MILEAGE =", value, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageNotEqualTo(Long value) {
            addCriterion("BEGIN_MILEAGE <>", value, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageGreaterThan(Long value) {
            addCriterion("BEGIN_MILEAGE >", value, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageGreaterThanOrEqualTo(Long value) {
            addCriterion("BEGIN_MILEAGE >=", value, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageLessThan(Long value) {
            addCriterion("BEGIN_MILEAGE <", value, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageLessThanOrEqualTo(Long value) {
            addCriterion("BEGIN_MILEAGE <=", value, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageIn(List<Integer> values) {
            addCriterion("BEGIN_MILEAGE in", values, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageNotIn(List<Integer> values) {
            addCriterion("BEGIN_MILEAGE not in", values, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageBetween(Long value1, Long value2) {
            addCriterion("BEGIN_MILEAGE between", value1, value2, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andBeginMileageNotBetween(Long value1, Long value2) {
            addCriterion("BEGIN_MILEAGE not between", value1, value2, "beginMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmIsNull() {
            addCriterion("END_NAGM is null");
            return (Criteria) this;
        }

        public Criteria andEndNagmIsNotNull() {
            addCriterion("END_NAGM is not null");
            return (Criteria) this;
        }

        public Criteria andEndNagmEqualTo(String value) {
            addCriterion("END_NAGM =", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmNotEqualTo(String value) {
            addCriterion("END_NAGM <>", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmGreaterThan(String value) {
            addCriterion("END_NAGM >", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmGreaterThanOrEqualTo(String value) {
            addCriterion("END_NAGM >=", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmLessThan(String value) {
            addCriterion("END_NAGM <", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmLessThanOrEqualTo(String value) {
            addCriterion("END_NAGM <=", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmLike(String value) {
            addCriterion("END_NAGM like", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmNotLike(String value) {
            addCriterion("END_NAGM not like", value, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmIn(List<String> values) {
            addCriterion("END_NAGM in", values, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmNotIn(List<String> values) {
            addCriterion("END_NAGM not in", values, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmBetween(String value1, String value2) {
            addCriterion("END_NAGM between", value1, value2, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmNotBetween(String value1, String value2) {
            addCriterion("END_NAGM not between", value1, value2, "endNagm");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageIsNull() {
            addCriterion("END_NAGM_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageIsNotNull() {
            addCriterion("END_NAGM_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageEqualTo(Long value) {
            addCriterion("END_NAGM_MILEAGE =", value, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageNotEqualTo(Long value) {
            addCriterion("END_NAGM_MILEAGE <>", value, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageGreaterThan(Long value) {
            addCriterion("END_NAGM_MILEAGE >", value, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageGreaterThanOrEqualTo(Long value) {
            addCriterion("END_NAGM_MILEAGE >=", value, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageLessThan(Long value) {
            addCriterion("END_NAGM_MILEAGE <", value, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageLessThanOrEqualTo(Long value) {
            addCriterion("END_NAGM_MILEAGE <=", value, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageIn(List<Integer> values) {
            addCriterion("END_NAGM_MILEAGE in", values, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageNotIn(List<Integer> values) {
            addCriterion("END_NAGM_MILEAGE not in", values, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageBetween(Long value1, Long value2) {
            addCriterion("END_NAGM_MILEAGE between", value1, value2, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndNagmMileageNotBetween(Long value1, Long value2) {
            addCriterion("END_NAGM_MILEAGE not between", value1, value2, "endNagmMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageIsNull() {
            addCriterion("END_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andEndMileageIsNotNull() {
            addCriterion("END_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andEndMileageEqualTo(Long value) {
            addCriterion("END_MILEAGE =", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageNotEqualTo(Long value) {
            addCriterion("END_MILEAGE <>", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageGreaterThan(Long value) {
            addCriterion("END_MILEAGE >", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageGreaterThanOrEqualTo(Long value) {
            addCriterion("END_MILEAGE >=", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageLessThan(Long value) {
            addCriterion("END_MILEAGE <", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageLessThanOrEqualTo(Long value) {
            addCriterion("END_MILEAGE <=", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageIn(List<Integer> values) {
            addCriterion("END_MILEAGE in", values, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageNotIn(List<Integer> values) {
            addCriterion("END_MILEAGE not in", values, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageBetween(Long value1, Long value2) {
            addCriterion("END_MILEAGE between", value1, value2, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageNotBetween(Long value1, Long value2) {
            addCriterion("END_MILEAGE not between", value1, value2, "endMileage");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountIsNull() {
            addCriterion("ROD_EARTHING_BODY_COUNT is null");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountIsNotNull() {
            addCriterion("ROD_EARTHING_BODY_COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountEqualTo(Long value) {
            addCriterion("ROD_EARTHING_BODY_COUNT =", value, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountNotEqualTo(Long value) {
            addCriterion("ROD_EARTHING_BODY_COUNT <>", value, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountGreaterThan(Long value) {
            addCriterion("ROD_EARTHING_BODY_COUNT >", value, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountGreaterThanOrEqualTo(Long value) {
            addCriterion("ROD_EARTHING_BODY_COUNT >=", value, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountLessThan(Long value) {
            addCriterion("ROD_EARTHING_BODY_COUNT <", value, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountLessThanOrEqualTo(Long value) {
            addCriterion("ROD_EARTHING_BODY_COUNT <=", value, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountIn(List<Integer> values) {
            addCriterion("ROD_EARTHING_BODY_COUNT in", values, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountNotIn(List<Integer> values) {
            addCriterion("ROD_EARTHING_BODY_COUNT not in", values, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountBetween(Long value1, Long value2) {
            addCriterion("ROD_EARTHING_BODY_COUNT between", value1, value2, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andRodEarthingBodyCountNotBetween(Long value1, Long value2) {
            addCriterion("ROD_EARTHING_BODY_COUNT not between", value1, value2, "rodEarthingBodyCount");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthIsNull() {
            addCriterion("STRIP_GROUND_BODY_LENGTH is null");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthIsNotNull() {
            addCriterion("STRIP_GROUND_BODY_LENGTH is not null");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthEqualTo(BigDecimal value) {
            addCriterion("STRIP_GROUND_BODY_LENGTH =", value, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthNotEqualTo(BigDecimal value) {
            addCriterion("STRIP_GROUND_BODY_LENGTH <>", value, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthGreaterThan(BigDecimal value) {
            addCriterion("STRIP_GROUND_BODY_LENGTH >", value, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("STRIP_GROUND_BODY_LENGTH >=", value, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthLessThan(BigDecimal value) {
            addCriterion("STRIP_GROUND_BODY_LENGTH <", value, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("STRIP_GROUND_BODY_LENGTH <=", value, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthIn(List<BigDecimal> values) {
            addCriterion("STRIP_GROUND_BODY_LENGTH in", values, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthNotIn(List<BigDecimal> values) {
            addCriterion("STRIP_GROUND_BODY_LENGTH not in", values, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("STRIP_GROUND_BODY_LENGTH between", value1, value2, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andStripGroundBodyLengthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("STRIP_GROUND_BODY_LENGTH not between", value1, value2, "stripGroundBodyLength");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceIsNull() {
            addCriterion("GROUNDING_RESISTANCE is null");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceIsNotNull() {
            addCriterion("GROUNDING_RESISTANCE is not null");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceEqualTo(BigDecimal value) {
            addCriterion("GROUNDING_RESISTANCE =", value, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceNotEqualTo(BigDecimal value) {
            addCriterion("GROUNDING_RESISTANCE <>", value, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceGreaterThan(BigDecimal value) {
            addCriterion("GROUNDING_RESISTANCE >", value, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GROUNDING_RESISTANCE >=", value, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceLessThan(BigDecimal value) {
            addCriterion("GROUNDING_RESISTANCE <", value, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GROUNDING_RESISTANCE <=", value, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceIn(List<BigDecimal> values) {
            addCriterion("GROUNDING_RESISTANCE in", values, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceNotIn(List<BigDecimal> values) {
            addCriterion("GROUNDING_RESISTANCE not in", values, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GROUNDING_RESISTANCE between", value1, value2, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundingResistanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GROUNDING_RESISTANCE not between", value1, value2, "groundingResistance");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationIsNull() {
            addCriterion("GROUND_RELATIVE_LOCATION is null");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationIsNotNull() {
            addCriterion("GROUND_RELATIVE_LOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationEqualTo(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION =", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationNotEqualTo(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION <>", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationGreaterThan(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION >", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationGreaterThanOrEqualTo(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION >=", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationLessThan(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION <", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationLessThanOrEqualTo(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION <=", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationLike(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION like", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationNotLike(String value) {
            addCriterion("GROUND_RELATIVE_LOCATION not like", value, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationIn(List<String> values) {
            addCriterion("GROUND_RELATIVE_LOCATION in", values, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationNotIn(List<String> values) {
            addCriterion("GROUND_RELATIVE_LOCATION not in", values, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationBetween(String value1, String value2) {
            addCriterion("GROUND_RELATIVE_LOCATION between", value1, value2, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andGroundRelativeLocationNotBetween(String value1, String value2) {
            addCriterion("GROUND_RELATIVE_LOCATION not between", value1, value2, "groundRelativeLocation");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateIsNull() {
            addCriterion("DEVICE_MANUFACTURE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateIsNotNull() {
            addCriterion("DEVICE_MANUFACTURE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateEqualTo(Date value) {
            addCriterion("DEVICE_MANUFACTURE_DATE =", value, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateNotEqualTo(Date value) {
            addCriterion("DEVICE_MANUFACTURE_DATE <>", value, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateGreaterThan(Date value) {
            addCriterion("DEVICE_MANUFACTURE_DATE >", value, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateGreaterThanOrEqualTo(Date value) {
            addCriterion("DEVICE_MANUFACTURE_DATE >=", value, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateLessThan(Date value) {
            addCriterion("DEVICE_MANUFACTURE_DATE <", value, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateLessThanOrEqualTo(Date value) {
            addCriterion("DEVICE_MANUFACTURE_DATE <=", value, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateIn(List<Date> values) {
            addCriterion("DEVICE_MANUFACTURE_DATE in", values, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateNotIn(List<Date> values) {
            addCriterion("DEVICE_MANUFACTURE_DATE not in", values, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateBetween(Date value1, Date value2) {
            addCriterion("DEVICE_MANUFACTURE_DATE between", value1, value2, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufactureDateNotBetween(Date value1, Date value2) {
            addCriterion("DEVICE_MANUFACTURE_DATE not between", value1, value2, "deviceManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateIsNull() {
            addCriterion("MATERIAL_MANUFACTURE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateIsNotNull() {
            addCriterion("MATERIAL_MANUFACTURE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateEqualTo(Date value) {
            addCriterion("MATERIAL_MANUFACTURE_DATE =", value, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateNotEqualTo(Date value) {
            addCriterion("MATERIAL_MANUFACTURE_DATE <>", value, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateGreaterThan(Date value) {
            addCriterion("MATERIAL_MANUFACTURE_DATE >", value, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateGreaterThanOrEqualTo(Date value) {
            addCriterion("MATERIAL_MANUFACTURE_DATE >=", value, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateLessThan(Date value) {
            addCriterion("MATERIAL_MANUFACTURE_DATE <", value, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateLessThanOrEqualTo(Date value) {
            addCriterion("MATERIAL_MANUFACTURE_DATE <=", value, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateIn(List<Date> values) {
            addCriterion("MATERIAL_MANUFACTURE_DATE in", values, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateNotIn(List<Date> values) {
            addCriterion("MATERIAL_MANUFACTURE_DATE not in", values, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateBetween(Date value1, Date value2) {
            addCriterion("MATERIAL_MANUFACTURE_DATE between", value1, value2, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andMaterialManufactureDateNotBetween(Date value1, Date value2) {
            addCriterion("MATERIAL_MANUFACTURE_DATE not between", value1, value2, "materialManufactureDate");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerIsNull() {
            addCriterion("DEVICE_MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerIsNotNull() {
            addCriterion("DEVICE_MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerEqualTo(String value) {
            addCriterion("DEVICE_MANUFACTURER =", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerNotEqualTo(String value) {
            addCriterion("DEVICE_MANUFACTURER <>", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerGreaterThan(String value) {
            addCriterion("DEVICE_MANUFACTURER >", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_MANUFACTURER >=", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerLessThan(String value) {
            addCriterion("DEVICE_MANUFACTURER <", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_MANUFACTURER <=", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerLike(String value) {
            addCriterion("DEVICE_MANUFACTURER like", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerNotLike(String value) {
            addCriterion("DEVICE_MANUFACTURER not like", value, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerIn(List<String> values) {
            addCriterion("DEVICE_MANUFACTURER in", values, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerNotIn(List<String> values) {
            addCriterion("DEVICE_MANUFACTURER not in", values, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerBetween(String value1, String value2) {
            addCriterion("DEVICE_MANUFACTURER between", value1, value2, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceManufacturerNotBetween(String value1, String value2) {
            addCriterion("DEVICE_MANUFACTURER not between", value1, value2, "deviceManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberIsNull() {
            addCriterion("MATERIAL_FACTORY_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberIsNotNull() {
            addCriterion("MATERIAL_FACTORY_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberEqualTo(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER =", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberNotEqualTo(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER <>", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberGreaterThan(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER >", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER >=", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberLessThan(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER <", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER <=", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberLike(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER like", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberNotLike(String value) {
            addCriterion("MATERIAL_FACTORY_NUMBER not like", value, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberIn(List<String> values) {
            addCriterion("MATERIAL_FACTORY_NUMBER in", values, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberNotIn(List<String> values) {
            addCriterion("MATERIAL_FACTORY_NUMBER not in", values, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberBetween(String value1, String value2) {
            addCriterion("MATERIAL_FACTORY_NUMBER between", value1, value2, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialFactoryNumberNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_FACTORY_NUMBER not between", value1, value2, "materialFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerIsNull() {
            addCriterion("MATERIAL_MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerIsNotNull() {
            addCriterion("MATERIAL_MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerEqualTo(String value) {
            addCriterion("MATERIAL_MANUFACTURER =", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerNotEqualTo(String value) {
            addCriterion("MATERIAL_MANUFACTURER <>", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerGreaterThan(String value) {
            addCriterion("MATERIAL_MANUFACTURER >", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_MANUFACTURER >=", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerLessThan(String value) {
            addCriterion("MATERIAL_MANUFACTURER <", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_MANUFACTURER <=", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerLike(String value) {
            addCriterion("MATERIAL_MANUFACTURER like", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerNotLike(String value) {
            addCriterion("MATERIAL_MANUFACTURER not like", value, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerIn(List<String> values) {
            addCriterion("MATERIAL_MANUFACTURER in", values, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerNotIn(List<String> values) {
            addCriterion("MATERIAL_MANUFACTURER not in", values, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerBetween(String value1, String value2) {
            addCriterion("MATERIAL_MANUFACTURER between", value1, value2, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andMaterialManufacturerNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_MANUFACTURER not between", value1, value2, "materialManufacturer");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberIsNull() {
            addCriterion("DEVICE_FACTORY_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberIsNotNull() {
            addCriterion("DEVICE_FACTORY_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberEqualTo(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER =", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberNotEqualTo(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER <>", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberGreaterThan(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER >", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER >=", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberLessThan(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER <", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER <=", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberLike(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER like", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberNotLike(String value) {
            addCriterion("DEVICE_FACTORY_NUMBER not like", value, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberIn(List<String> values) {
            addCriterion("DEVICE_FACTORY_NUMBER in", values, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberNotIn(List<String> values) {
            addCriterion("DEVICE_FACTORY_NUMBER not in", values, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberBetween(String value1, String value2) {
            addCriterion("DEVICE_FACTORY_NUMBER between", value1, value2, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andDeviceFactoryNumberNotBetween(String value1, String value2) {
            addCriterion("DEVICE_FACTORY_NUMBER not between", value1, value2, "deviceFactoryNumber");
            return (Criteria) this;
        }

        public Criteria andInserviceDateIsNull() {
            addCriterion("INSERVICE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInserviceDateIsNotNull() {
            addCriterion("INSERVICE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInserviceDateEqualTo(Date value) {
            addCriterion("INSERVICE_DATE =", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateNotEqualTo(Date value) {
            addCriterion("INSERVICE_DATE <>", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateGreaterThan(Date value) {
            addCriterion("INSERVICE_DATE >", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateGreaterThanOrEqualTo(Date value) {
            addCriterion("INSERVICE_DATE >=", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateLessThan(Date value) {
            addCriterion("INSERVICE_DATE <", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateLessThanOrEqualTo(Date value) {
            addCriterion("INSERVICE_DATE <=", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateIn(List<Date> values) {
            addCriterion("INSERVICE_DATE in", values, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateNotIn(List<Date> values) {
            addCriterion("INSERVICE_DATE not in", values, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateBetween(Date value1, Date value2) {
            addCriterion("INSERVICE_DATE between", value1, value2, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateNotBetween(Date value1, Date value2) {
            addCriterion("INSERVICE_DATE not between", value1, value2, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNull() {
            addCriterion("MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNotNull() {
            addCriterion("MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerEqualTo(String value) {
            addCriterion("MANUFACTURER =", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotEqualTo(String value) {
            addCriterion("MANUFACTURER <>", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThan(String value) {
            addCriterion("MANUFACTURER >", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("MANUFACTURER >=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThan(String value) {
            addCriterion("MANUFACTURER <", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThanOrEqualTo(String value) {
            addCriterion("MANUFACTURER <=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLike(String value) {
            addCriterion("MANUFACTURER like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotLike(String value) {
            addCriterion("MANUFACTURER not like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerIn(List<String> values) {
            addCriterion("MANUFACTURER in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotIn(List<String> values) {
            addCriterion("MANUFACTURER not in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerBetween(String value1, String value2) {
            addCriterion("MANUFACTURER between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotBetween(String value1, String value2) {
            addCriterion("MANUFACTURER not between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andSerialNumberIsNull() {
            addCriterion("SERIAL_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andSerialNumberIsNotNull() {
            addCriterion("SERIAL_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andSerialNumberEqualTo(String value) {
            addCriterion("SERIAL_NUMBER =", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotEqualTo(String value) {
            addCriterion("SERIAL_NUMBER <>", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberGreaterThan(String value) {
            addCriterion("SERIAL_NUMBER >", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberGreaterThanOrEqualTo(String value) {
            addCriterion("SERIAL_NUMBER >=", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberLessThan(String value) {
            addCriterion("SERIAL_NUMBER <", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberLessThanOrEqualTo(String value) {
            addCriterion("SERIAL_NUMBER <=", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberLike(String value) {
            addCriterion("SERIAL_NUMBER like", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotLike(String value) {
            addCriterion("SERIAL_NUMBER not like", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberIn(List<String> values) {
            addCriterion("SERIAL_NUMBER in", values, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotIn(List<String> values) {
            addCriterion("SERIAL_NUMBER not in", values, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberBetween(String value1, String value2) {
            addCriterion("SERIAL_NUMBER between", value1, value2, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotBetween(String value1, String value2) {
            addCriterion("SERIAL_NUMBER not between", value1, value2, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIsNull() {
            addCriterion("COATING_MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIsNotNull() {
            addCriterion("COATING_MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialEqualTo(String value) {
            addCriterion("COATING_MATERIAL =", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotEqualTo(String value) {
            addCriterion("COATING_MATERIAL <>", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialGreaterThan(String value) {
            addCriterion("COATING_MATERIAL >", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_MATERIAL >=", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLessThan(String value) {
            addCriterion("COATING_MATERIAL <", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLessThanOrEqualTo(String value) {
            addCriterion("COATING_MATERIAL <=", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLike(String value) {
            addCriterion("COATING_MATERIAL like", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotLike(String value) {
            addCriterion("COATING_MATERIAL not like", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIn(List<String> values) {
            addCriterion("COATING_MATERIAL in", values, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotIn(List<String> values) {
            addCriterion("COATING_MATERIAL not in", values, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialBetween(String value1, String value2) {
            addCriterion("COATING_MATERIAL between", value1, value2, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotBetween(String value1, String value2) {
            addCriterion("COATING_MATERIAL not between", value1, value2, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyIsNull() {
            addCriterion("ASSEMBLY_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyIsNotNull() {
            addCriterion("ASSEMBLY_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyEqualTo(String value) {
            addCriterion("ASSEMBLY_COMPANY =", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyNotEqualTo(String value) {
            addCriterion("ASSEMBLY_COMPANY <>", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyGreaterThan(String value) {
            addCriterion("ASSEMBLY_COMPANY >", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("ASSEMBLY_COMPANY >=", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyLessThan(String value) {
            addCriterion("ASSEMBLY_COMPANY <", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyLessThanOrEqualTo(String value) {
            addCriterion("ASSEMBLY_COMPANY <=", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyLike(String value) {
            addCriterion("ASSEMBLY_COMPANY like", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyNotLike(String value) {
            addCriterion("ASSEMBLY_COMPANY not like", value, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyIn(List<String> values) {
            addCriterion("ASSEMBLY_COMPANY in", values, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyNotIn(List<String> values) {
            addCriterion("ASSEMBLY_COMPANY not in", values, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyBetween(String value1, String value2) {
            addCriterion("ASSEMBLY_COMPANY between", value1, value2, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andAssemblyCompanyNotBetween(String value1, String value2) {
            addCriterion("ASSEMBLY_COMPANY not between", value1, value2, "assemblyCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIsNull() {
            addCriterion("TESTING_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIsNotNull() {
            addCriterion("TESTING_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyEqualTo(String value) {
            addCriterion("TESTING_COMPANY =", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotEqualTo(String value) {
            addCriterion("TESTING_COMPANY <>", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyGreaterThan(String value) {
            addCriterion("TESTING_COMPANY >", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("TESTING_COMPANY >=", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLessThan(String value) {
            addCriterion("TESTING_COMPANY <", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLessThanOrEqualTo(String value) {
            addCriterion("TESTING_COMPANY <=", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLike(String value) {
            addCriterion("TESTING_COMPANY like", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotLike(String value) {
            addCriterion("TESTING_COMPANY not like", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIn(List<String> values) {
            addCriterion("TESTING_COMPANY in", values, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotIn(List<String> values) {
            addCriterion("TESTING_COMPANY not in", values, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyBetween(String value1, String value2) {
            addCriterion("TESTING_COMPANY between", value1, value2, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotBetween(String value1, String value2) {
            addCriterion("TESTING_COMPANY not between", value1, value2, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNull() {
            addCriterion("RECORDER is null");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNotNull() {
            addCriterion("RECORDER is not null");
            return (Criteria) this;
        }

        public Criteria andRecorderEqualTo(String value) {
            addCriterion("RECORDER =", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotEqualTo(String value) {
            addCriterion("RECORDER <>", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThan(String value) {
            addCriterion("RECORDER >", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThanOrEqualTo(String value) {
            addCriterion("RECORDER >=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThan(String value) {
            addCriterion("RECORDER <", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThanOrEqualTo(String value) {
            addCriterion("RECORDER <=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLike(String value) {
            addCriterion("RECORDER like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotLike(String value) {
            addCriterion("RECORDER not like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderIn(List<String> values) {
            addCriterion("RECORDER in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotIn(List<String> values) {
            addCriterion("RECORDER not in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderBetween(String value1, String value2) {
            addCriterion("RECORDER between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotBetween(String value1, String value2) {
            addCriterion("RECORDER not between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("RECORD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("RECORD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(Date value) {
            addCriterion("RECORD_TIME =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(Date value) {
            addCriterion("RECORD_TIME <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(Date value) {
            addCriterion("RECORD_TIME >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(Date value) {
            addCriterion("RECORD_TIME <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<Date> values) {
            addCriterion("RECORD_TIME in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<Date> values) {
            addCriterion("RECORD_TIME not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME not between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("REMARKS =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("REMARKS <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("REMARKS >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("REMARKS >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("REMARKS <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("REMARKS <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("REMARKS like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("REMARKS not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("REMARKS in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("REMARKS not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("REMARKS between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("REMARKS not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNull() {
            addCriterion("ORG_BIZ_PATH is null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNotNull() {
            addCriterion("ORG_BIZ_PATH is not null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH =", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <>", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThan(String value) {
            addCriterion("ORG_BIZ_PATH >", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH >=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThan(String value) {
            addCriterion("ORG_BIZ_PATH <", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLike(String value) {
            addCriterion("ORG_BIZ_PATH like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotLike(String value) {
            addCriterion("ORG_BIZ_PATH not like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH not in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH not between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}